USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[CaptureListInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.CaptureListInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	CaptureList Table Insert
-- =============================================
CREATE PROCEDURE CaptureListInsert

	@CaptureListId int,
	@CaptureId int,
	@PlayerId varchar(30)
	

AS
BEGIN

	INSERT INTO [CaptureList] (	
			CaptureListId,
			CaptureId,
			PlayerId 
		  )
	VALUES(	
			@CaptureListId,
			@CaptureId,
			@PlayerId 
		  )

END
GO

